Release 10.1A: OpenEdge Development:
Java Open Clients

Setting and getting values on the SDOParameters object

An SDOParameters object in com.progress.open4gl can be supplied as a parameter to the SDOResultSet factory method that allows you to control various ResultSet properties. You need to set only the values that differ from the defaults. The methods to set and get these values on the SDOParameters object follow.

The following method sets the row ID of the first row to be fetched from the created and opened SDOResultSet:

void setRowIdentity(String rowId)

A null rowId is equivalent to not calling setRowIdentity() (also see the reOpenQuery(String rowId) extended method in the "Miscellaneous management methods" section). Usually, it is more efficient to use setRowIdentity() than to create the SDOResultSet and then call the extended method, absolute(String rowId), to reposition the cursor on the specified row.

If you create the SDOResultSet in PREFETCH scrolling mode, you cannot access rows before the rowId that you set with setRowIdentity(). For more information on PREFETCH, see the "Understanding SDOResultSet scrolling modes" section.

The rowId value is equivalent to the value returned by the 4GL ROWID function and the SDOResultSet.getRowIdentity() method. For more information on ROWID, see OpenEdge Development: Progress 4GL Handbook or the appropriate OpenEdge DataServer Guide for any DataServer accessed by the SmartDataObject. For more information on the SDOResultSet.getRowIdentity() method, see the "Miscellaneous management methods" section.

The following method gets the row ID of the first row to be fetched from the created and opened SDOResultSet:

Syntax

String getRowIdentity()

The following method sets the number of rows the scrolling mechanism fetches each time it accesses the AppServer:

Syntax

void setFetchSize(int fetchsize)

The default is 200.

The following method gets the number of rows the scrolling mechanism fetches each time it accesses the AppServer:

Syntax

int getFetchSize()

The following method sets the Stateless mode for the SDOResultSet:

Syntax

void setStateless(boolean state)

Specify state as true for a stateless SDOResultSet and false for a non-stateless SDOResultSet. For more information, see the "Understanding SDOResultSet stateless mode" section.

The following method gets the Stateless mode for the SDOResultSet:

Syntax

boolean getStateless()

For more information, see the "Understanding SDOResultSet stateless mode" section.

The following method sets the scrolling mode for the SDOResultSet specified as a class constant in com.progress.open4gl.SDOScrollingMode:

Syntax

void setScrollingMode(SDOScrollingMode constant)

If the SDOResultSet is Stateless, the default is SDOScrollingMode.PREFETCH; otherwise, the default is SDOScrollingMode.KEEP_ROWS. The other supported scrolling mode is SDOScrollingMode.FORWARD_ONLY. For more information, see the "Understanding SDOResultSet scrolling modes" section.

The following method gets the scrolling mode specified for the SDOResultSet, returned as a class constant in com.progress.open4gl.SDOScrollingMode:

Syntax

SDOScrollingMode getScrollingMode()

For more information, see the "Understanding SDOResultSet scrolling modes" section.

The following method sets the maximum number of rows to be fetched when the scrolling mode is SDOScrollingMode.PREFETCH:

Syntax

void setPrefetchMaxRows(int maxRows)

The setPrefetchMaxRows() method has no effect for scrolling modes other than SDOScrollingMode.PREFETCH. The default for this mode is to get all the rows of the SDOResultSet. For more information, see the "Understanding SDOResultSet scrolling modes" section and the "Understanding SDOResultSet stateless mode" section.

The following method gets the value for the maximum number of rows to be fetched when the scrolling mode is SDOScrollingMode.PREFETCH:

Syntax

int getPrefetchMaxRows()

For more information, see the "Understanding SDOResultSet scrolling modes" section and the "Understanding SDOResultSet stateless mode" section.